for the ESI Price Exceptions Export.The ESI Price Exception Export function is used to create an export file of the detail of the "other" selling price or price exceptions applied to invoices for a range of dates by sales-type cost adjustments.
1. Follow the common External System Interface (ESI) overview and instructions found in the ESI menu overview.
2. At the Customer field, enter the customer ID code or customer mask for the ESI Price Exceptions Export.
If you are uncertain of the customer ID code, see Navigating Net Yield - Selecting a Customer ID Code.
3. A Select An Option window will display with the following options:
Select one, several, or all cost adjustment types by scrolling to the appropriate selection(s) and pressing Enter. An asterisk (*) will appear confirming your selection. Select EXIT to continue.
4. Enter the start date for the ESI Price Exceptions Export in the From Invoice Date field. Or, press Enter to accept the current system default – today's date.
5. Enter the end date for the ESI Price Exceptions Export in the To Invoice Date field. Or, press Enter to accept the current system default – today's date.
6. At the File Name field, enter a name for the ESI Price Exceptions Export file and press Enter.
The following message will display: "ASC file (file name.asc) created in reports folder!!! Space bar to continue."
The ESI Price Exception Export file is saved to the Shared\NetYield\Data\Company Name\ESI Outboxfolder.
The file contains the following fields (ASC files do not have field headers):
| Field |
| Bill-to customer ID |
| Customer ship-to ID |
| Customer ship-to name |
| Sales order number |
| Invoice number |
| Invoice date |
| Customer purchase order number |
| Broker ID |
| Sales rep ID |
|
Item ID |
|
Item name |
| Quantity invoiced |
| Invoicing unit of measure |
| Net product selling price |
| Total other selling price |
| Total invoice price |
| Cost adjustment-type ID |
|
Invoice payment status:
|
| Cost adjustment amount per invoicing unit of measure |
| Total cost adjustment amount |
Security Required : Sales - Price Exceptions
| See Also |